UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHMpT1tEB+As0vR3suISYvD9iy07zeGKcO/ocOw9BWw='
WHERE
key_id = '65566c1c4f1130dfdba92491d744be91794cd13df481578702b1b7ab70ca2635'
AND (
token = 'BHMpT1tEB+As0vR3suISYvD9iy07zeGKcO/ocOw9BWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)