UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DnoKII8bHWiJVPoKswJU0vsSKurCLQpWlfbEwuQYM4g='
WHERE
key_id = '1a9dcd9b26e0cf952be8b52d7df43d33574f4087bd7d2c90f4f3021d7a1bd265'
AND (
token = 'DnoKII8bHWiJVPoKswJU0vsSKurCLQpWlfbEwuQYM4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)