UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5DtfpsPsx92MzoWOVFaW7Qz02L/hYawquvMIf0Y9uhQ='
WHERE
key_id = 'bc06b07df34fbf565ac9649750d8f5b7c4864240a3b6632bb94fedea53820c43'
AND (
token = '5DtfpsPsx92MzoWOVFaW7Qz02L/hYawquvMIf0Y9uhQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)