UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QgS583a6pTde/2AHL7/IrGjm2xIbDEuN3WsWQJr2rxA='
WHERE
key_id = '8ba587ece84b1c6fe307be5efd14152d2606ce0f1fdcb5c2a84a2e3f6687e0a2'
AND (
token = 'QgS583a6pTde/2AHL7/IrGjm2xIbDEuN3WsWQJr2rxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)