UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xPL2NPnmmXf1dRUoAbrOPjj4Au9rQp/QHb//aR6KD74='
WHERE
key_id = 'c48b8178ba9e88cab59440c036e344619e0ed01511e8b8abc0a79d206056e6ab'
AND (
token = 'xPL2NPnmmXf1dRUoAbrOPjj4Au9rQp/QHb//aR6KD74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)