UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGbC2s3EX4/qfvhYrl6dsyXNHbDKxiyMDEYwqADueq0='
WHERE
key_id = '9d19fd5c90997a651c50323c718c0b8b0b8a3aa363ee6bee27aa1db6a73b133d'
AND (
token = 'HGbC2s3EX4/qfvhYrl6dsyXNHbDKxiyMDEYwqADueq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)