UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dUj4YQtIJdfWGNmMfSceKZEna/ORk0geQ6tRCe8kWw='
WHERE
key_id = '3e18298bb26eb509b42be68210f67e4f5c56707af027c19dfdbec04e82e69519'
AND (
token = '9dUj4YQtIJdfWGNmMfSceKZEna/ORk0geQ6tRCe8kWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)