UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8h1RS2pglUOEdfrAwqere/Pc9M3ThRiS7LUWYwNLrA='
WHERE
key_id = '077d21fa482eb5253a47119713e5c9a1538a51f1c90f7f016a0d0347bfa99701'
AND (
token = 'J8h1RS2pglUOEdfrAwqere/Pc9M3ThRiS7LUWYwNLrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)