UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SriZlOiB3HH3Jq6uE3O/X/o6QRptgmxcd4OgMNTi8A='
WHERE
key_id = '31e8d66c8f6509e27023b62957bf88cda2ef1b2c6287a1c05c258116d5908347'
AND (
token = '6SriZlOiB3HH3Jq6uE3O/X/o6QRptgmxcd4OgMNTi8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)