UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JUuaZgJ1CiUKTMs2/g1PgVY68JqKmQ+l16trq4Haoig='
WHERE
key_id = 'c8b270cbab0bc0594504e2466f88de6ef206627c7d8a3c74ebe8119c3a54cbd9'
AND (
token = 'JUuaZgJ1CiUKTMs2/g1PgVY68JqKmQ+l16trq4Haoig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)