UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IsnXNn7Pc3Av0B7+DuX1xEKpFV21/KR5BK9+APJhscs='
WHERE
key_id = '3a7395486aa55a75b4ebaa002219ea0619b33f41aee393e9c52d49e1c38896ba'
AND (
token = 'IsnXNn7Pc3Av0B7+DuX1xEKpFV21/KR5BK9+APJhscs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)