UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsyg2NzIxbCXywjOOMCzJBJKdCd0lpowplv6hi9dw+k='
WHERE
key_id = 'e9f1dabb0a52d744c7fdba4dfe7d2b181e6922cfc836d2ef1c60e794f341444a'
AND (
token = 'zsyg2NzIxbCXywjOOMCzJBJKdCd0lpowplv6hi9dw+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)