UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gAWRsEJ9gmXFZeovFX3IuRs0uhITX0wS0WsU8LVy/4='
WHERE
key_id = '768defee05e0242e81f277f72f94b559b7ca9ad5b137fbd9e8b50a31abab8ba8'
AND (
token = '1gAWRsEJ9gmXFZeovFX3IuRs0uhITX0wS0WsU8LVy/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)