UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TIQMZPGjlJ2oH0BdYi4kmgFDT6GYCHQd7z230YKLphI='
WHERE
key_id = 'a970ae2148dd9ed4f4ac6d4b30463f2cf67fe557105a804be53e634b7192f004'
AND (
token = 'TIQMZPGjlJ2oH0BdYi4kmgFDT6GYCHQd7z230YKLphI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)