UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5Mnt69jM8xBLIlB+XXU4EowaVLSlSyfbt0UBZVDkM4='
WHERE
key_id = 'f7a1cbc5cf89203ffe22bfed7f2fc003a04d99121c04095743f1df6e3fc6c07c'
AND (
token = 'G5Mnt69jM8xBLIlB+XXU4EowaVLSlSyfbt0UBZVDkM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)