UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BY4RhnG7O/v21iq1kt7fQUGNA7lpHZciFSUgYjyp9cc='
WHERE
key_id = 'ea787e258ea33f84649828a582bfc641d3e98c473f1a0d66d2d5ba440a9ab43e'
AND (
token = 'BY4RhnG7O/v21iq1kt7fQUGNA7lpHZciFSUgYjyp9cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)