UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zk2c+Gfppl09b5sgacIBQ4SO3ESe+yZZ/MWSt9123zc='
WHERE
key_id = 'cf21167b2be1a04e251d3cfc5f22f5c89f97d754ece5e4ab2d15f017d9747cd8'
AND (
token = 'Zk2c+Gfppl09b5sgacIBQ4SO3ESe+yZZ/MWSt9123zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)