UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8yxCalAD9DOZdbrtG0JudrJfslgkpwFZWkLJFklZhI='
WHERE
key_id = '18c441602c8e6afdc4efd85afd384cbe27aec91df68c386da695ae3066fe0bbd'
AND (
token = 'p8yxCalAD9DOZdbrtG0JudrJfslgkpwFZWkLJFklZhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)