UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCl+jVd7yJ0ZsPdHLsvsabuGg8koUdq8yxDmZjmMriY='
WHERE
key_id = '5417708fcb1f5773837bfecac330d50c95e27ec1dd7cd347e9daf240fc0da981'
AND (
token = 'HCl+jVd7yJ0ZsPdHLsvsabuGg8koUdq8yxDmZjmMriY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)