UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VO7zHQo9Mks66xU8rEthkVjDUToEQOstQppSK6lrAxU='
WHERE
key_id = 'ffcd6ab943a0406366804be0ea28c6fbfb84c20d3c989179f27b99a76119a73e'
AND (
token = 'VO7zHQo9Mks66xU8rEthkVjDUToEQOstQppSK6lrAxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)