UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cv9V7YbPvktL4EVmddqvfivpIfDdt7e6ja2ZtSURdI='
WHERE
key_id = '82d8d7c7065af71b16e514ac998309d53899a68cc3235cc8ab514868fa37c123'
AND (
token = '4cv9V7YbPvktL4EVmddqvfivpIfDdt7e6ja2ZtSURdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)