UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g5ySIYRHl/xnHCIAilM9LYTovyOcFyxnvESppTpAc9Y='
WHERE
key_id = '9f5a42bb19b729704d0309a3891a087c5baee4614a35f0ebdc734bcb8c1ca8a7'
AND (
token = 'g5ySIYRHl/xnHCIAilM9LYTovyOcFyxnvESppTpAc9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)