UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNQONQDpmVG4vkh+1QC1aYNXKz4lf7ko7yJg9vasPXU='
WHERE
key_id = 'ed1b16250d2893b8cb442a296fad21e75d92244d8588f607441a53d4ae6f325b'
AND (
token = 'ZNQONQDpmVG4vkh+1QC1aYNXKz4lf7ko7yJg9vasPXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)