UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bBgTHBMYJZqLg22xgNsn7zs32xq60gGRzVLkGCBCdw='
WHERE
key_id = 'e9ec8d53c78b64433f63d245d9c87ca1fe53eff3485a268e933ee2996c7cb736'
AND (
token = '1bBgTHBMYJZqLg22xgNsn7zs32xq60gGRzVLkGCBCdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)