UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qEjo70m9bEdHEwuJcypgzOvhvY5rc2Iybu4tHMivvs='
WHERE
key_id = 'fb2977a1a4cead129f95d87799b87aef1ba8082d745cf0c586ae1b59df232218'
AND (
token = '6qEjo70m9bEdHEwuJcypgzOvhvY5rc2Iybu4tHMivvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)