UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K4hr9F3cOcIKYgLBqD+AnS4DngX9cIxFLzAWqAKbrc8='
WHERE
key_id = '49f3ac476b742ea72b8c5424b327201e256377bb46c12149b962813c1d18306e'
AND (
token = 'K4hr9F3cOcIKYgLBqD+AnS4DngX9cIxFLzAWqAKbrc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)