UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iM0cWMDrFZB90wBGz2aJ8NqCepH8hy+P7+esdk37EKE='
WHERE
key_id = 'ae27de1f80e163f7a03a99a0e104f6ff71f3dcc99980633faa3fdb026b7c1304'
AND (
token = 'iM0cWMDrFZB90wBGz2aJ8NqCepH8hy+P7+esdk37EKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)